mysql - SELECT COUNT with JOIN optimization for tables with > 100M rows